package db.migration._201808;

import org.flywaydb.core.api.migration.jdbc.JdbcMigration;

import java.sql.Connection;
import java.sql.PreparedStatement;

public class V201808201201_00001__INSERT_PERSON implements JdbcMigration {
//    @Override
//    public void migrate(JdbcTemplate jdbcTemplate)  {
//        String sql = "insert into PERSON(first_name,last_name)values(?,?)";
//        jdbcTemplate.update(sql, "p_prod", "p_prod1");
//    }

    @Override
    public void migrate(Connection connection) throws Exception {
        String sql = "insert into PERSON(first_name,last_name)values(?,?)";
        PreparedStatement statement = connection.prepareStatement(sql);
        statement.setString(1,"p_prod");
        statement.setString(2,"2_prod2");
    }
}
